package com.zhongwang.business.gen.entity;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class BusGeneralHoursExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public BusGeneralHoursExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andProCodeIsNull() {
            addCriterion("pro_code is null");
            return (Criteria) this;
        }

        public Criteria andProCodeIsNotNull() {
            addCriterion("pro_code is not null");
            return (Criteria) this;
        }

        public Criteria andProCodeEqualTo(String value) {
            addCriterion("pro_code =", value, "proCode");
            return (Criteria) this;
        }

        public Criteria andProCodeNotEqualTo(String value) {
            addCriterion("pro_code <>", value, "proCode");
            return (Criteria) this;
        }

        public Criteria andProCodeGreaterThan(String value) {
            addCriterion("pro_code >", value, "proCode");
            return (Criteria) this;
        }

        public Criteria andProCodeGreaterThanOrEqualTo(String value) {
            addCriterion("pro_code >=", value, "proCode");
            return (Criteria) this;
        }

        public Criteria andProCodeLessThan(String value) {
            addCriterion("pro_code <", value, "proCode");
            return (Criteria) this;
        }

        public Criteria andProCodeLessThanOrEqualTo(String value) {
            addCriterion("pro_code <=", value, "proCode");
            return (Criteria) this;
        }

        public Criteria andProCodeLike(String value) {
            addCriterion("pro_code like", value, "proCode");
            return (Criteria) this;
        }

        public Criteria andProCodeNotLike(String value) {
            addCriterion("pro_code not like", value, "proCode");
            return (Criteria) this;
        }

        public Criteria andProCodeIn(List<String> values) {
            addCriterion("pro_code in", values, "proCode");
            return (Criteria) this;
        }

        public Criteria andProCodeNotIn(List<String> values) {
            addCriterion("pro_code not in", values, "proCode");
            return (Criteria) this;
        }

        public Criteria andProCodeBetween(String value1, String value2) {
            addCriterion("pro_code between", value1, value2, "proCode");
            return (Criteria) this;
        }

        public Criteria andProCodeNotBetween(String value1, String value2) {
            addCriterion("pro_code not between", value1, value2, "proCode");
            return (Criteria) this;
        }

        public Criteria andPartIsNull() {
            addCriterion("part is null");
            return (Criteria) this;
        }

        public Criteria andPartIsNotNull() {
            addCriterion("part is not null");
            return (Criteria) this;
        }

        public Criteria andPartEqualTo(String value) {
            addCriterion("part =", value, "part");
            return (Criteria) this;
        }

        public Criteria andPartNotEqualTo(String value) {
            addCriterion("part <>", value, "part");
            return (Criteria) this;
        }

        public Criteria andPartGreaterThan(String value) {
            addCriterion("part >", value, "part");
            return (Criteria) this;
        }

        public Criteria andPartGreaterThanOrEqualTo(String value) {
            addCriterion("part >=", value, "part");
            return (Criteria) this;
        }

        public Criteria andPartLessThan(String value) {
            addCriterion("part <", value, "part");
            return (Criteria) this;
        }

        public Criteria andPartLessThanOrEqualTo(String value) {
            addCriterion("part <=", value, "part");
            return (Criteria) this;
        }

        public Criteria andPartLike(String value) {
            addCriterion("part like", value, "part");
            return (Criteria) this;
        }

        public Criteria andPartNotLike(String value) {
            addCriterion("part not like", value, "part");
            return (Criteria) this;
        }

        public Criteria andPartIn(List<String> values) {
            addCriterion("part in", values, "part");
            return (Criteria) this;
        }

        public Criteria andPartNotIn(List<String> values) {
            addCriterion("part not in", values, "part");
            return (Criteria) this;
        }

        public Criteria andPartBetween(String value1, String value2) {
            addCriterion("part between", value1, value2, "part");
            return (Criteria) this;
        }

        public Criteria andPartNotBetween(String value1, String value2) {
            addCriterion("part not between", value1, value2, "part");
            return (Criteria) this;
        }

        public Criteria andTypeIsNull() {
            addCriterion("type is null");
            return (Criteria) this;
        }

        public Criteria andTypeIsNotNull() {
            addCriterion("type is not null");
            return (Criteria) this;
        }

        public Criteria andTypeEqualTo(Integer value) {
            addCriterion("type =", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotEqualTo(Integer value) {
            addCriterion("type <>", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThan(Integer value) {
            addCriterion("type >", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("type >=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThan(Integer value) {
            addCriterion("type <", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThanOrEqualTo(Integer value) {
            addCriterion("type <=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeIn(List<Integer> values) {
            addCriterion("type in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotIn(List<Integer> values) {
            addCriterion("type not in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeBetween(Integer value1, Integer value2) {
            addCriterion("type between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("type not between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andLaborTypeIsNull() {
            addCriterion("labor_type is null");
            return (Criteria) this;
        }

        public Criteria andLaborTypeIsNotNull() {
            addCriterion("labor_type is not null");
            return (Criteria) this;
        }

        public Criteria andLaborTypeEqualTo(Integer value) {
            addCriterion("labor_type =", value, "laborType");
            return (Criteria) this;
        }

        public Criteria andLaborTypeNotEqualTo(Integer value) {
            addCriterion("labor_type <>", value, "laborType");
            return (Criteria) this;
        }

        public Criteria andLaborTypeGreaterThan(Integer value) {
            addCriterion("labor_type >", value, "laborType");
            return (Criteria) this;
        }

        public Criteria andLaborTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("labor_type >=", value, "laborType");
            return (Criteria) this;
        }

        public Criteria andLaborTypeLessThan(Integer value) {
            addCriterion("labor_type <", value, "laborType");
            return (Criteria) this;
        }

        public Criteria andLaborTypeLessThanOrEqualTo(Integer value) {
            addCriterion("labor_type <=", value, "laborType");
            return (Criteria) this;
        }

        public Criteria andLaborTypeIn(List<Integer> values) {
            addCriterion("labor_type in", values, "laborType");
            return (Criteria) this;
        }

        public Criteria andLaborTypeNotIn(List<Integer> values) {
            addCriterion("labor_type not in", values, "laborType");
            return (Criteria) this;
        }

        public Criteria andLaborTypeBetween(Integer value1, Integer value2) {
            addCriterion("labor_type between", value1, value2, "laborType");
            return (Criteria) this;
        }

        public Criteria andLaborTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("labor_type not between", value1, value2, "laborType");
            return (Criteria) this;
        }

        public Criteria andLaborNameIsNull() {
            addCriterion("labor_name is null");
            return (Criteria) this;
        }

        public Criteria andLaborNameIsNotNull() {
            addCriterion("labor_name is not null");
            return (Criteria) this;
        }

        public Criteria andLaborNameEqualTo(String value) {
            addCriterion("labor_name =", value, "laborName");
            return (Criteria) this;
        }

        public Criteria andLaborNameNotEqualTo(String value) {
            addCriterion("labor_name <>", value, "laborName");
            return (Criteria) this;
        }

        public Criteria andLaborNameGreaterThan(String value) {
            addCriterion("labor_name >", value, "laborName");
            return (Criteria) this;
        }

        public Criteria andLaborNameGreaterThanOrEqualTo(String value) {
            addCriterion("labor_name >=", value, "laborName");
            return (Criteria) this;
        }

        public Criteria andLaborNameLessThan(String value) {
            addCriterion("labor_name <", value, "laborName");
            return (Criteria) this;
        }

        public Criteria andLaborNameLessThanOrEqualTo(String value) {
            addCriterion("labor_name <=", value, "laborName");
            return (Criteria) this;
        }

        public Criteria andLaborNameLike(String value) {
            addCriterion("labor_name like", value, "laborName");
            return (Criteria) this;
        }

        public Criteria andLaborNameNotLike(String value) {
            addCriterion("labor_name not like", value, "laborName");
            return (Criteria) this;
        }

        public Criteria andLaborNameIn(List<String> values) {
            addCriterion("labor_name in", values, "laborName");
            return (Criteria) this;
        }

        public Criteria andLaborNameNotIn(List<String> values) {
            addCriterion("labor_name not in", values, "laborName");
            return (Criteria) this;
        }

        public Criteria andLaborNameBetween(String value1, String value2) {
            addCriterion("labor_name between", value1, value2, "laborName");
            return (Criteria) this;
        }

        public Criteria andLaborNameNotBetween(String value1, String value2) {
            addCriterion("labor_name not between", value1, value2, "laborName");
            return (Criteria) this;
        }

        public Criteria andLaborNumIsNull() {
            addCriterion("labor_num is null");
            return (Criteria) this;
        }

        public Criteria andLaborNumIsNotNull() {
            addCriterion("labor_num is not null");
            return (Criteria) this;
        }

        public Criteria andLaborNumEqualTo(BigDecimal value) {
            addCriterion("labor_num =", value, "laborNum");
            return (Criteria) this;
        }

        public Criteria andLaborNumNotEqualTo(BigDecimal value) {
            addCriterion("labor_num <>", value, "laborNum");
            return (Criteria) this;
        }

        public Criteria andLaborNumGreaterThan(BigDecimal value) {
            addCriterion("labor_num >", value, "laborNum");
            return (Criteria) this;
        }

        public Criteria andLaborNumGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("labor_num >=", value, "laborNum");
            return (Criteria) this;
        }

        public Criteria andLaborNumLessThan(BigDecimal value) {
            addCriterion("labor_num <", value, "laborNum");
            return (Criteria) this;
        }

        public Criteria andLaborNumLessThanOrEqualTo(BigDecimal value) {
            addCriterion("labor_num <=", value, "laborNum");
            return (Criteria) this;
        }

        public Criteria andLaborNumIn(List<BigDecimal> values) {
            addCriterion("labor_num in", values, "laborNum");
            return (Criteria) this;
        }

        public Criteria andLaborNumNotIn(List<BigDecimal> values) {
            addCriterion("labor_num not in", values, "laborNum");
            return (Criteria) this;
        }

        public Criteria andLaborNumBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("labor_num between", value1, value2, "laborNum");
            return (Criteria) this;
        }

        public Criteria andLaborNumNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("labor_num not between", value1, value2, "laborNum");
            return (Criteria) this;
        }

        public Criteria andUnitIsNull() {
            addCriterion("unit is null");
            return (Criteria) this;
        }

        public Criteria andUnitIsNotNull() {
            addCriterion("unit is not null");
            return (Criteria) this;
        }

        public Criteria andUnitEqualTo(String value) {
            addCriterion("unit =", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotEqualTo(String value) {
            addCriterion("unit <>", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitGreaterThan(String value) {
            addCriterion("unit >", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitGreaterThanOrEqualTo(String value) {
            addCriterion("unit >=", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitLessThan(String value) {
            addCriterion("unit <", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitLessThanOrEqualTo(String value) {
            addCriterion("unit <=", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitLike(String value) {
            addCriterion("unit like", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotLike(String value) {
            addCriterion("unit not like", value, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitIn(List<String> values) {
            addCriterion("unit in", values, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotIn(List<String> values) {
            addCriterion("unit not in", values, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitBetween(String value1, String value2) {
            addCriterion("unit between", value1, value2, "unit");
            return (Criteria) this;
        }

        public Criteria andUnitNotBetween(String value1, String value2) {
            addCriterion("unit not between", value1, value2, "unit");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andBatIdIsNull() {
            addCriterion("bat_id is null");
            return (Criteria) this;
        }

        public Criteria andBatIdIsNotNull() {
            addCriterion("bat_id is not null");
            return (Criteria) this;
        }

        public Criteria andBatIdEqualTo(Integer value) {
            addCriterion("bat_id =", value, "batId");
            return (Criteria) this;
        }

        public Criteria andBatIdNotEqualTo(Integer value) {
            addCriterion("bat_id <>", value, "batId");
            return (Criteria) this;
        }

        public Criteria andBatIdGreaterThan(Integer value) {
            addCriterion("bat_id >", value, "batId");
            return (Criteria) this;
        }

        public Criteria andBatIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("bat_id >=", value, "batId");
            return (Criteria) this;
        }

        public Criteria andBatIdLessThan(Integer value) {
            addCriterion("bat_id <", value, "batId");
            return (Criteria) this;
        }

        public Criteria andBatIdLessThanOrEqualTo(Integer value) {
            addCriterion("bat_id <=", value, "batId");
            return (Criteria) this;
        }

        public Criteria andBatIdIn(List<Integer> values) {
            addCriterion("bat_id in", values, "batId");
            return (Criteria) this;
        }

        public Criteria andBatIdNotIn(List<Integer> values) {
            addCriterion("bat_id not in", values, "batId");
            return (Criteria) this;
        }

        public Criteria andBatIdBetween(Integer value1, Integer value2) {
            addCriterion("bat_id between", value1, value2, "batId");
            return (Criteria) this;
        }

        public Criteria andBatIdNotBetween(Integer value1, Integer value2) {
            addCriterion("bat_id not between", value1, value2, "batId");
            return (Criteria) this;
        }

        public Criteria andPlaceDeliveryIsNull() {
            addCriterion("place_delivery is null");
            return (Criteria) this;
        }

        public Criteria andPlaceDeliveryIsNotNull() {
            addCriterion("place_delivery is not null");
            return (Criteria) this;
        }

        public Criteria andPlaceDeliveryEqualTo(String value) {
            addCriterion("place_delivery =", value, "placeDelivery");
            return (Criteria) this;
        }

        public Criteria andPlaceDeliveryNotEqualTo(String value) {
            addCriterion("place_delivery <>", value, "placeDelivery");
            return (Criteria) this;
        }

        public Criteria andPlaceDeliveryGreaterThan(String value) {
            addCriterion("place_delivery >", value, "placeDelivery");
            return (Criteria) this;
        }

        public Criteria andPlaceDeliveryGreaterThanOrEqualTo(String value) {
            addCriterion("place_delivery >=", value, "placeDelivery");
            return (Criteria) this;
        }

        public Criteria andPlaceDeliveryLessThan(String value) {
            addCriterion("place_delivery <", value, "placeDelivery");
            return (Criteria) this;
        }

        public Criteria andPlaceDeliveryLessThanOrEqualTo(String value) {
            addCriterion("place_delivery <=", value, "placeDelivery");
            return (Criteria) this;
        }

        public Criteria andPlaceDeliveryLike(String value) {
            addCriterion("place_delivery like", value, "placeDelivery");
            return (Criteria) this;
        }

        public Criteria andPlaceDeliveryNotLike(String value) {
            addCriterion("place_delivery not like", value, "placeDelivery");
            return (Criteria) this;
        }

        public Criteria andPlaceDeliveryIn(List<String> values) {
            addCriterion("place_delivery in", values, "placeDelivery");
            return (Criteria) this;
        }

        public Criteria andPlaceDeliveryNotIn(List<String> values) {
            addCriterion("place_delivery not in", values, "placeDelivery");
            return (Criteria) this;
        }

        public Criteria andPlaceDeliveryBetween(String value1, String value2) {
            addCriterion("place_delivery between", value1, value2, "placeDelivery");
            return (Criteria) this;
        }

        public Criteria andPlaceDeliveryNotBetween(String value1, String value2) {
            addCriterion("place_delivery not between", value1, value2, "placeDelivery");
            return (Criteria) this;
        }

        public Criteria andDestinationIsNull() {
            addCriterion("destination is null");
            return (Criteria) this;
        }

        public Criteria andDestinationIsNotNull() {
            addCriterion("destination is not null");
            return (Criteria) this;
        }

        public Criteria andDestinationEqualTo(String value) {
            addCriterion("destination =", value, "destination");
            return (Criteria) this;
        }

        public Criteria andDestinationNotEqualTo(String value) {
            addCriterion("destination <>", value, "destination");
            return (Criteria) this;
        }

        public Criteria andDestinationGreaterThan(String value) {
            addCriterion("destination >", value, "destination");
            return (Criteria) this;
        }

        public Criteria andDestinationGreaterThanOrEqualTo(String value) {
            addCriterion("destination >=", value, "destination");
            return (Criteria) this;
        }

        public Criteria andDestinationLessThan(String value) {
            addCriterion("destination <", value, "destination");
            return (Criteria) this;
        }

        public Criteria andDestinationLessThanOrEqualTo(String value) {
            addCriterion("destination <=", value, "destination");
            return (Criteria) this;
        }

        public Criteria andDestinationLike(String value) {
            addCriterion("destination like", value, "destination");
            return (Criteria) this;
        }

        public Criteria andDestinationNotLike(String value) {
            addCriterion("destination not like", value, "destination");
            return (Criteria) this;
        }

        public Criteria andDestinationIn(List<String> values) {
            addCriterion("destination in", values, "destination");
            return (Criteria) this;
        }

        public Criteria andDestinationNotIn(List<String> values) {
            addCriterion("destination not in", values, "destination");
            return (Criteria) this;
        }

        public Criteria andDestinationBetween(String value1, String value2) {
            addCriterion("destination between", value1, value2, "destination");
            return (Criteria) this;
        }

        public Criteria andDestinationNotBetween(String value1, String value2) {
            addCriterion("destination not between", value1, value2, "destination");
            return (Criteria) this;
        }

        public Criteria andCarNumIsNull() {
            addCriterion("car_num is null");
            return (Criteria) this;
        }

        public Criteria andCarNumIsNotNull() {
            addCriterion("car_num is not null");
            return (Criteria) this;
        }

        public Criteria andCarNumEqualTo(Integer value) {
            addCriterion("car_num =", value, "carNum");
            return (Criteria) this;
        }

        public Criteria andCarNumNotEqualTo(Integer value) {
            addCriterion("car_num <>", value, "carNum");
            return (Criteria) this;
        }

        public Criteria andCarNumGreaterThan(Integer value) {
            addCriterion("car_num >", value, "carNum");
            return (Criteria) this;
        }

        public Criteria andCarNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("car_num >=", value, "carNum");
            return (Criteria) this;
        }

        public Criteria andCarNumLessThan(Integer value) {
            addCriterion("car_num <", value, "carNum");
            return (Criteria) this;
        }

        public Criteria andCarNumLessThanOrEqualTo(Integer value) {
            addCriterion("car_num <=", value, "carNum");
            return (Criteria) this;
        }

        public Criteria andCarNumIn(List<Integer> values) {
            addCriterion("car_num in", values, "carNum");
            return (Criteria) this;
        }

        public Criteria andCarNumNotIn(List<Integer> values) {
            addCriterion("car_num not in", values, "carNum");
            return (Criteria) this;
        }

        public Criteria andCarNumBetween(Integer value1, Integer value2) {
            addCriterion("car_num between", value1, value2, "carNum");
            return (Criteria) this;
        }

        public Criteria andCarNumNotBetween(Integer value1, Integer value2) {
            addCriterion("car_num not between", value1, value2, "carNum");
            return (Criteria) this;
        }

        public Criteria andDistanceIsNull() {
            addCriterion("distance is null");
            return (Criteria) this;
        }

        public Criteria andDistanceIsNotNull() {
            addCriterion("distance is not null");
            return (Criteria) this;
        }

        public Criteria andDistanceEqualTo(BigDecimal value) {
            addCriterion("distance =", value, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceNotEqualTo(BigDecimal value) {
            addCriterion("distance <>", value, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceGreaterThan(BigDecimal value) {
            addCriterion("distance >", value, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("distance >=", value, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceLessThan(BigDecimal value) {
            addCriterion("distance <", value, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("distance <=", value, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceIn(List<BigDecimal> values) {
            addCriterion("distance in", values, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceNotIn(List<BigDecimal> values) {
            addCriterion("distance not in", values, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("distance between", value1, value2, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("distance not between", value1, value2, "distance");
            return (Criteria) this;
        }

        public Criteria andDistanceUnitIsNull() {
            addCriterion("distance_unit is null");
            return (Criteria) this;
        }

        public Criteria andDistanceUnitIsNotNull() {
            addCriterion("distance_unit is not null");
            return (Criteria) this;
        }

        public Criteria andDistanceUnitEqualTo(String value) {
            addCriterion("distance_unit =", value, "distanceUnit");
            return (Criteria) this;
        }

        public Criteria andDistanceUnitNotEqualTo(String value) {
            addCriterion("distance_unit <>", value, "distanceUnit");
            return (Criteria) this;
        }

        public Criteria andDistanceUnitGreaterThan(String value) {
            addCriterion("distance_unit >", value, "distanceUnit");
            return (Criteria) this;
        }

        public Criteria andDistanceUnitGreaterThanOrEqualTo(String value) {
            addCriterion("distance_unit >=", value, "distanceUnit");
            return (Criteria) this;
        }

        public Criteria andDistanceUnitLessThan(String value) {
            addCriterion("distance_unit <", value, "distanceUnit");
            return (Criteria) this;
        }

        public Criteria andDistanceUnitLessThanOrEqualTo(String value) {
            addCriterion("distance_unit <=", value, "distanceUnit");
            return (Criteria) this;
        }

        public Criteria andDistanceUnitLike(String value) {
            addCriterion("distance_unit like", value, "distanceUnit");
            return (Criteria) this;
        }

        public Criteria andDistanceUnitNotLike(String value) {
            addCriterion("distance_unit not like", value, "distanceUnit");
            return (Criteria) this;
        }

        public Criteria andDistanceUnitIn(List<String> values) {
            addCriterion("distance_unit in", values, "distanceUnit");
            return (Criteria) this;
        }

        public Criteria andDistanceUnitNotIn(List<String> values) {
            addCriterion("distance_unit not in", values, "distanceUnit");
            return (Criteria) this;
        }

        public Criteria andDistanceUnitBetween(String value1, String value2) {
            addCriterion("distance_unit between", value1, value2, "distanceUnit");
            return (Criteria) this;
        }

        public Criteria andDistanceUnitNotBetween(String value1, String value2) {
            addCriterion("distance_unit not between", value1, value2, "distanceUnit");
            return (Criteria) this;
        }

        public Criteria andPriceIsNull() {
            addCriterion("price is null");
            return (Criteria) this;
        }

        public Criteria andPriceIsNotNull() {
            addCriterion("price is not null");
            return (Criteria) this;
        }

        public Criteria andPriceEqualTo(BigDecimal value) {
            addCriterion("price =", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotEqualTo(BigDecimal value) {
            addCriterion("price <>", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThan(BigDecimal value) {
            addCriterion("price >", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("price >=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThan(BigDecimal value) {
            addCriterion("price <", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("price <=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceIn(List<BigDecimal> values) {
            addCriterion("price in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotIn(List<BigDecimal> values) {
            addCriterion("price not in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("price between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("price not between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andDsIdIsNull() {
            addCriterion("ds_id is null");
            return (Criteria) this;
        }

        public Criteria andDsIdIsNotNull() {
            addCriterion("ds_id is not null");
            return (Criteria) this;
        }

        public Criteria andDsIdEqualTo(Integer value) {
            addCriterion("ds_id =", value, "dsId");
            return (Criteria) this;
        }

        public Criteria andDsIdNotEqualTo(Integer value) {
            addCriterion("ds_id <>", value, "dsId");
            return (Criteria) this;
        }

        public Criteria andDsIdGreaterThan(Integer value) {
            addCriterion("ds_id >", value, "dsId");
            return (Criteria) this;
        }

        public Criteria andDsIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ds_id >=", value, "dsId");
            return (Criteria) this;
        }

        public Criteria andDsIdLessThan(Integer value) {
            addCriterion("ds_id <", value, "dsId");
            return (Criteria) this;
        }

        public Criteria andDsIdLessThanOrEqualTo(Integer value) {
            addCriterion("ds_id <=", value, "dsId");
            return (Criteria) this;
        }

        public Criteria andDsIdIn(List<Integer> values) {
            addCriterion("ds_id in", values, "dsId");
            return (Criteria) this;
        }

        public Criteria andDsIdNotIn(List<Integer> values) {
            addCriterion("ds_id not in", values, "dsId");
            return (Criteria) this;
        }

        public Criteria andDsIdBetween(Integer value1, Integer value2) {
            addCriterion("ds_id between", value1, value2, "dsId");
            return (Criteria) this;
        }

        public Criteria andDsIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ds_id not between", value1, value2, "dsId");
            return (Criteria) this;
        }

        public Criteria andPriceTypeIsNull() {
            addCriterion("price_type is null");
            return (Criteria) this;
        }

        public Criteria andPriceTypeIsNotNull() {
            addCriterion("price_type is not null");
            return (Criteria) this;
        }

        public Criteria andPriceTypeEqualTo(Integer value) {
            addCriterion("price_type =", value, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceTypeNotEqualTo(Integer value) {
            addCriterion("price_type <>", value, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceTypeGreaterThan(Integer value) {
            addCriterion("price_type >", value, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("price_type >=", value, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceTypeLessThan(Integer value) {
            addCriterion("price_type <", value, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceTypeLessThanOrEqualTo(Integer value) {
            addCriterion("price_type <=", value, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceTypeIn(List<Integer> values) {
            addCriterion("price_type in", values, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceTypeNotIn(List<Integer> values) {
            addCriterion("price_type not in", values, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceTypeBetween(Integer value1, Integer value2) {
            addCriterion("price_type between", value1, value2, "priceType");
            return (Criteria) this;
        }

        public Criteria andPriceTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("price_type not between", value1, value2, "priceType");
            return (Criteria) this;
        }

        public Criteria andDataUseTypeIsNull() {
            addCriterion("data_use_type is null");
            return (Criteria) this;
        }

        public Criteria andDataUseTypeIsNotNull() {
            addCriterion("data_use_type is not null");
            return (Criteria) this;
        }

        public Criteria andDataUseTypeEqualTo(Integer value) {
            addCriterion("data_use_type =", value, "dataUseType");
            return (Criteria) this;
        }

        public Criteria andDataUseTypeNotEqualTo(Integer value) {
            addCriterion("data_use_type <>", value, "dataUseType");
            return (Criteria) this;
        }

        public Criteria andDataUseTypeGreaterThan(Integer value) {
            addCriterion("data_use_type >", value, "dataUseType");
            return (Criteria) this;
        }

        public Criteria andDataUseTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("data_use_type >=", value, "dataUseType");
            return (Criteria) this;
        }

        public Criteria andDataUseTypeLessThan(Integer value) {
            addCriterion("data_use_type <", value, "dataUseType");
            return (Criteria) this;
        }

        public Criteria andDataUseTypeLessThanOrEqualTo(Integer value) {
            addCriterion("data_use_type <=", value, "dataUseType");
            return (Criteria) this;
        }

        public Criteria andDataUseTypeIn(List<Integer> values) {
            addCriterion("data_use_type in", values, "dataUseType");
            return (Criteria) this;
        }

        public Criteria andDataUseTypeNotIn(List<Integer> values) {
            addCriterion("data_use_type not in", values, "dataUseType");
            return (Criteria) this;
        }

        public Criteria andDataUseTypeBetween(Integer value1, Integer value2) {
            addCriterion("data_use_type between", value1, value2, "dataUseType");
            return (Criteria) this;
        }

        public Criteria andDataUseTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("data_use_type not between", value1, value2, "dataUseType");
            return (Criteria) this;
        }

        public Criteria andSourceProCodeIsNull() {
            addCriterion("source_pro_code is null");
            return (Criteria) this;
        }

        public Criteria andSourceProCodeIsNotNull() {
            addCriterion("source_pro_code is not null");
            return (Criteria) this;
        }

        public Criteria andSourceProCodeEqualTo(String value) {
            addCriterion("source_pro_code =", value, "sourceProCode");
            return (Criteria) this;
        }

        public Criteria andSourceProCodeNotEqualTo(String value) {
            addCriterion("source_pro_code <>", value, "sourceProCode");
            return (Criteria) this;
        }

        public Criteria andSourceProCodeGreaterThan(String value) {
            addCriterion("source_pro_code >", value, "sourceProCode");
            return (Criteria) this;
        }

        public Criteria andSourceProCodeGreaterThanOrEqualTo(String value) {
            addCriterion("source_pro_code >=", value, "sourceProCode");
            return (Criteria) this;
        }

        public Criteria andSourceProCodeLessThan(String value) {
            addCriterion("source_pro_code <", value, "sourceProCode");
            return (Criteria) this;
        }

        public Criteria andSourceProCodeLessThanOrEqualTo(String value) {
            addCriterion("source_pro_code <=", value, "sourceProCode");
            return (Criteria) this;
        }

        public Criteria andSourceProCodeLike(String value) {
            addCriterion("source_pro_code like", value, "sourceProCode");
            return (Criteria) this;
        }

        public Criteria andSourceProCodeNotLike(String value) {
            addCriterion("source_pro_code not like", value, "sourceProCode");
            return (Criteria) this;
        }

        public Criteria andSourceProCodeIn(List<String> values) {
            addCriterion("source_pro_code in", values, "sourceProCode");
            return (Criteria) this;
        }

        public Criteria andSourceProCodeNotIn(List<String> values) {
            addCriterion("source_pro_code not in", values, "sourceProCode");
            return (Criteria) this;
        }

        public Criteria andSourceProCodeBetween(String value1, String value2) {
            addCriterion("source_pro_code between", value1, value2, "sourceProCode");
            return (Criteria) this;
        }

        public Criteria andSourceProCodeNotBetween(String value1, String value2) {
            addCriterion("source_pro_code not between", value1, value2, "sourceProCode");
            return (Criteria) this;
        }

        public Criteria andSourcePartIsNull() {
            addCriterion("source_part is null");
            return (Criteria) this;
        }

        public Criteria andSourcePartIsNotNull() {
            addCriterion("source_part is not null");
            return (Criteria) this;
        }

        public Criteria andSourcePartEqualTo(String value) {
            addCriterion("source_part =", value, "sourcePart");
            return (Criteria) this;
        }

        public Criteria andSourcePartNotEqualTo(String value) {
            addCriterion("source_part <>", value, "sourcePart");
            return (Criteria) this;
        }

        public Criteria andSourcePartGreaterThan(String value) {
            addCriterion("source_part >", value, "sourcePart");
            return (Criteria) this;
        }

        public Criteria andSourcePartGreaterThanOrEqualTo(String value) {
            addCriterion("source_part >=", value, "sourcePart");
            return (Criteria) this;
        }

        public Criteria andSourcePartLessThan(String value) {
            addCriterion("source_part <", value, "sourcePart");
            return (Criteria) this;
        }

        public Criteria andSourcePartLessThanOrEqualTo(String value) {
            addCriterion("source_part <=", value, "sourcePart");
            return (Criteria) this;
        }

        public Criteria andSourcePartLike(String value) {
            addCriterion("source_part like", value, "sourcePart");
            return (Criteria) this;
        }

        public Criteria andSourcePartNotLike(String value) {
            addCriterion("source_part not like", value, "sourcePart");
            return (Criteria) this;
        }

        public Criteria andSourcePartIn(List<String> values) {
            addCriterion("source_part in", values, "sourcePart");
            return (Criteria) this;
        }

        public Criteria andSourcePartNotIn(List<String> values) {
            addCriterion("source_part not in", values, "sourcePart");
            return (Criteria) this;
        }

        public Criteria andSourcePartBetween(String value1, String value2) {
            addCriterion("source_part between", value1, value2, "sourcePart");
            return (Criteria) this;
        }

        public Criteria andSourcePartNotBetween(String value1, String value2) {
            addCriterion("source_part not between", value1, value2, "sourcePart");
            return (Criteria) this;
        }

        public Criteria andMajorIsNull() {
            addCriterion("major is null");
            return (Criteria) this;
        }

        public Criteria andMajorIsNotNull() {
            addCriterion("major is not null");
            return (Criteria) this;
        }

        public Criteria andMajorEqualTo(String value) {
            addCriterion("major =", value, "major");
            return (Criteria) this;
        }

        public Criteria andMajorNotEqualTo(String value) {
            addCriterion("major <>", value, "major");
            return (Criteria) this;
        }

        public Criteria andMajorGreaterThan(String value) {
            addCriterion("major >", value, "major");
            return (Criteria) this;
        }

        public Criteria andMajorGreaterThanOrEqualTo(String value) {
            addCriterion("major >=", value, "major");
            return (Criteria) this;
        }

        public Criteria andMajorLessThan(String value) {
            addCriterion("major <", value, "major");
            return (Criteria) this;
        }

        public Criteria andMajorLessThanOrEqualTo(String value) {
            addCriterion("major <=", value, "major");
            return (Criteria) this;
        }

        public Criteria andMajorLike(String value) {
            addCriterion("major like", value, "major");
            return (Criteria) this;
        }

        public Criteria andMajorNotLike(String value) {
            addCriterion("major not like", value, "major");
            return (Criteria) this;
        }

        public Criteria andMajorIn(List<String> values) {
            addCriterion("major in", values, "major");
            return (Criteria) this;
        }

        public Criteria andMajorNotIn(List<String> values) {
            addCriterion("major not in", values, "major");
            return (Criteria) this;
        }

        public Criteria andMajorBetween(String value1, String value2) {
            addCriterion("major between", value1, value2, "major");
            return (Criteria) this;
        }

        public Criteria andMajorNotBetween(String value1, String value2) {
            addCriterion("major not between", value1, value2, "major");
            return (Criteria) this;
        }

        public Criteria andGetDateIsNull() {
            addCriterion("get_date is null");
            return (Criteria) this;
        }

        public Criteria andGetDateIsNotNull() {
            addCriterion("get_date is not null");
            return (Criteria) this;
        }

        public Criteria andGetDateEqualTo(Date value) {
            addCriterion("get_date =", value, "getDate");
            return (Criteria) this;
        }

        public Criteria andGetDateNotEqualTo(Date value) {
            addCriterion("get_date <>", value, "getDate");
            return (Criteria) this;
        }

        public Criteria andGetDateGreaterThan(Date value) {
            addCriterion("get_date >", value, "getDate");
            return (Criteria) this;
        }

        public Criteria andGetDateGreaterThanOrEqualTo(Date value) {
            addCriterion("get_date >=", value, "getDate");
            return (Criteria) this;
        }

        public Criteria andGetDateLessThan(Date value) {
            addCriterion("get_date <", value, "getDate");
            return (Criteria) this;
        }

        public Criteria andGetDateLessThanOrEqualTo(Date value) {
            addCriterion("get_date <=", value, "getDate");
            return (Criteria) this;
        }

        public Criteria andGetDateIn(List<Date> values) {
            addCriterion("get_date in", values, "getDate");
            return (Criteria) this;
        }

        public Criteria andGetDateNotIn(List<Date> values) {
            addCriterion("get_date not in", values, "getDate");
            return (Criteria) this;
        }

        public Criteria andGetDateBetween(Date value1, Date value2) {
            addCriterion("get_date between", value1, value2, "getDate");
            return (Criteria) this;
        }

        public Criteria andGetDateNotBetween(Date value1, Date value2) {
            addCriterion("get_date not between", value1, value2, "getDate");
            return (Criteria) this;
        }

        public Criteria andAmountIsNull() {
            addCriterion("amount is null");
            return (Criteria) this;
        }

        public Criteria andAmountIsNotNull() {
            addCriterion("amount is not null");
            return (Criteria) this;
        }

        public Criteria andAmountEqualTo(BigDecimal value) {
            addCriterion("amount =", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotEqualTo(BigDecimal value) {
            addCriterion("amount <>", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountGreaterThan(BigDecimal value) {
            addCriterion("amount >", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("amount >=", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountLessThan(BigDecimal value) {
            addCriterion("amount <", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("amount <=", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountIn(List<BigDecimal> values) {
            addCriterion("amount in", values, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotIn(List<BigDecimal> values) {
            addCriterion("amount not in", values, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("amount between", value1, value2, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("amount not between", value1, value2, "amount");
            return (Criteria) this;
        }

        public Criteria andGetUidIsNull() {
            addCriterion("get_uid is null");
            return (Criteria) this;
        }

        public Criteria andGetUidIsNotNull() {
            addCriterion("get_uid is not null");
            return (Criteria) this;
        }

        public Criteria andGetUidEqualTo(Integer value) {
            addCriterion("get_uid =", value, "getUid");
            return (Criteria) this;
        }

        public Criteria andGetUidNotEqualTo(Integer value) {
            addCriterion("get_uid <>", value, "getUid");
            return (Criteria) this;
        }

        public Criteria andGetUidGreaterThan(Integer value) {
            addCriterion("get_uid >", value, "getUid");
            return (Criteria) this;
        }

        public Criteria andGetUidGreaterThanOrEqualTo(Integer value) {
            addCriterion("get_uid >=", value, "getUid");
            return (Criteria) this;
        }

        public Criteria andGetUidLessThan(Integer value) {
            addCriterion("get_uid <", value, "getUid");
            return (Criteria) this;
        }

        public Criteria andGetUidLessThanOrEqualTo(Integer value) {
            addCriterion("get_uid <=", value, "getUid");
            return (Criteria) this;
        }

        public Criteria andGetUidIn(List<Integer> values) {
            addCriterion("get_uid in", values, "getUid");
            return (Criteria) this;
        }

        public Criteria andGetUidNotIn(List<Integer> values) {
            addCriterion("get_uid not in", values, "getUid");
            return (Criteria) this;
        }

        public Criteria andGetUidBetween(Integer value1, Integer value2) {
            addCriterion("get_uid between", value1, value2, "getUid");
            return (Criteria) this;
        }

        public Criteria andGetUidNotBetween(Integer value1, Integer value2) {
            addCriterion("get_uid not between", value1, value2, "getUid");
            return (Criteria) this;
        }

        public Criteria andMaterialIsNull() {
            addCriterion("material is null");
            return (Criteria) this;
        }

        public Criteria andMaterialIsNotNull() {
            addCriterion("material is not null");
            return (Criteria) this;
        }

        public Criteria andMaterialEqualTo(String value) {
            addCriterion("material =", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialNotEqualTo(String value) {
            addCriterion("material <>", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialGreaterThan(String value) {
            addCriterion("material >", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialGreaterThanOrEqualTo(String value) {
            addCriterion("material >=", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialLessThan(String value) {
            addCriterion("material <", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialLessThanOrEqualTo(String value) {
            addCriterion("material <=", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialLike(String value) {
            addCriterion("material like", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialNotLike(String value) {
            addCriterion("material not like", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialIn(List<String> values) {
            addCriterion("material in", values, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialNotIn(List<String> values) {
            addCriterion("material not in", values, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialBetween(String value1, String value2) {
            addCriterion("material between", value1, value2, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialNotBetween(String value1, String value2) {
            addCriterion("material not between", value1, value2, "material");
            return (Criteria) this;
        }

        public Criteria andPostNameIsNull() {
            addCriterion("post_name is null");
            return (Criteria) this;
        }

        public Criteria andPostNameIsNotNull() {
            addCriterion("post_name is not null");
            return (Criteria) this;
        }

        public Criteria andPostNameEqualTo(String value) {
            addCriterion("post_name =", value, "postName");
            return (Criteria) this;
        }

        public Criteria andPostNameNotEqualTo(String value) {
            addCriterion("post_name <>", value, "postName");
            return (Criteria) this;
        }

        public Criteria andPostNameGreaterThan(String value) {
            addCriterion("post_name >", value, "postName");
            return (Criteria) this;
        }

        public Criteria andPostNameGreaterThanOrEqualTo(String value) {
            addCriterion("post_name >=", value, "postName");
            return (Criteria) this;
        }

        public Criteria andPostNameLessThan(String value) {
            addCriterion("post_name <", value, "postName");
            return (Criteria) this;
        }

        public Criteria andPostNameLessThanOrEqualTo(String value) {
            addCriterion("post_name <=", value, "postName");
            return (Criteria) this;
        }

        public Criteria andPostNameLike(String value) {
            addCriterion("post_name like", value, "postName");
            return (Criteria) this;
        }

        public Criteria andPostNameNotLike(String value) {
            addCriterion("post_name not like", value, "postName");
            return (Criteria) this;
        }

        public Criteria andPostNameIn(List<String> values) {
            addCriterion("post_name in", values, "postName");
            return (Criteria) this;
        }

        public Criteria andPostNameNotIn(List<String> values) {
            addCriterion("post_name not in", values, "postName");
            return (Criteria) this;
        }

        public Criteria andPostNameBetween(String value1, String value2) {
            addCriterion("post_name between", value1, value2, "postName");
            return (Criteria) this;
        }

        public Criteria andPostNameNotBetween(String value1, String value2) {
            addCriterion("post_name not between", value1, value2, "postName");
            return (Criteria) this;
        }

        public Criteria andPostTelIsNull() {
            addCriterion("post_tel is null");
            return (Criteria) this;
        }

        public Criteria andPostTelIsNotNull() {
            addCriterion("post_tel is not null");
            return (Criteria) this;
        }

        public Criteria andPostTelEqualTo(String value) {
            addCriterion("post_tel =", value, "postTel");
            return (Criteria) this;
        }

        public Criteria andPostTelNotEqualTo(String value) {
            addCriterion("post_tel <>", value, "postTel");
            return (Criteria) this;
        }

        public Criteria andPostTelGreaterThan(String value) {
            addCriterion("post_tel >", value, "postTel");
            return (Criteria) this;
        }

        public Criteria andPostTelGreaterThanOrEqualTo(String value) {
            addCriterion("post_tel >=", value, "postTel");
            return (Criteria) this;
        }

        public Criteria andPostTelLessThan(String value) {
            addCriterion("post_tel <", value, "postTel");
            return (Criteria) this;
        }

        public Criteria andPostTelLessThanOrEqualTo(String value) {
            addCriterion("post_tel <=", value, "postTel");
            return (Criteria) this;
        }

        public Criteria andPostTelLike(String value) {
            addCriterion("post_tel like", value, "postTel");
            return (Criteria) this;
        }

        public Criteria andPostTelNotLike(String value) {
            addCriterion("post_tel not like", value, "postTel");
            return (Criteria) this;
        }

        public Criteria andPostTelIn(List<String> values) {
            addCriterion("post_tel in", values, "postTel");
            return (Criteria) this;
        }

        public Criteria andPostTelNotIn(List<String> values) {
            addCriterion("post_tel not in", values, "postTel");
            return (Criteria) this;
        }

        public Criteria andPostTelBetween(String value1, String value2) {
            addCriterion("post_tel between", value1, value2, "postTel");
            return (Criteria) this;
        }

        public Criteria andPostTelNotBetween(String value1, String value2) {
            addCriterion("post_tel not between", value1, value2, "postTel");
            return (Criteria) this;
        }

        public Criteria andPostDeptIsNull() {
            addCriterion("post_dept is null");
            return (Criteria) this;
        }

        public Criteria andPostDeptIsNotNull() {
            addCriterion("post_dept is not null");
            return (Criteria) this;
        }

        public Criteria andPostDeptEqualTo(String value) {
            addCriterion("post_dept =", value, "postDept");
            return (Criteria) this;
        }

        public Criteria andPostDeptNotEqualTo(String value) {
            addCriterion("post_dept <>", value, "postDept");
            return (Criteria) this;
        }

        public Criteria andPostDeptGreaterThan(String value) {
            addCriterion("post_dept >", value, "postDept");
            return (Criteria) this;
        }

        public Criteria andPostDeptGreaterThanOrEqualTo(String value) {
            addCriterion("post_dept >=", value, "postDept");
            return (Criteria) this;
        }

        public Criteria andPostDeptLessThan(String value) {
            addCriterion("post_dept <", value, "postDept");
            return (Criteria) this;
        }

        public Criteria andPostDeptLessThanOrEqualTo(String value) {
            addCriterion("post_dept <=", value, "postDept");
            return (Criteria) this;
        }

        public Criteria andPostDeptLike(String value) {
            addCriterion("post_dept like", value, "postDept");
            return (Criteria) this;
        }

        public Criteria andPostDeptNotLike(String value) {
            addCriterion("post_dept not like", value, "postDept");
            return (Criteria) this;
        }

        public Criteria andPostDeptIn(List<String> values) {
            addCriterion("post_dept in", values, "postDept");
            return (Criteria) this;
        }

        public Criteria andPostDeptNotIn(List<String> values) {
            addCriterion("post_dept not in", values, "postDept");
            return (Criteria) this;
        }

        public Criteria andPostDeptBetween(String value1, String value2) {
            addCriterion("post_dept between", value1, value2, "postDept");
            return (Criteria) this;
        }

        public Criteria andPostDeptNotBetween(String value1, String value2) {
            addCriterion("post_dept not between", value1, value2, "postDept");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveFlagIsNull() {
            addCriterion("is_effective_flag is null");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveFlagIsNotNull() {
            addCriterion("is_effective_flag is not null");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveFlagEqualTo(Integer value) {
            addCriterion("is_effective_flag =", value, "isEffectiveFlag");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveFlagNotEqualTo(Integer value) {
            addCriterion("is_effective_flag <>", value, "isEffectiveFlag");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveFlagGreaterThan(Integer value) {
            addCriterion("is_effective_flag >", value, "isEffectiveFlag");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_effective_flag >=", value, "isEffectiveFlag");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveFlagLessThan(Integer value) {
            addCriterion("is_effective_flag <", value, "isEffectiveFlag");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveFlagLessThanOrEqualTo(Integer value) {
            addCriterion("is_effective_flag <=", value, "isEffectiveFlag");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveFlagIn(List<Integer> values) {
            addCriterion("is_effective_flag in", values, "isEffectiveFlag");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveFlagNotIn(List<Integer> values) {
            addCriterion("is_effective_flag not in", values, "isEffectiveFlag");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveFlagBetween(Integer value1, Integer value2) {
            addCriterion("is_effective_flag between", value1, value2, "isEffectiveFlag");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("is_effective_flag not between", value1, value2, "isEffectiveFlag");
            return (Criteria) this;
        }

        public Criteria andCostIdIsNull() {
            addCriterion("cost_id is null");
            return (Criteria) this;
        }

        public Criteria andCostIdIsNotNull() {
            addCriterion("cost_id is not null");
            return (Criteria) this;
        }

        public Criteria andCostIdEqualTo(Integer value) {
            addCriterion("cost_id =", value, "costId");
            return (Criteria) this;
        }

        public Criteria andCostIdNotEqualTo(Integer value) {
            addCriterion("cost_id <>", value, "costId");
            return (Criteria) this;
        }

        public Criteria andCostIdGreaterThan(Integer value) {
            addCriterion("cost_id >", value, "costId");
            return (Criteria) this;
        }

        public Criteria andCostIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("cost_id >=", value, "costId");
            return (Criteria) this;
        }

        public Criteria andCostIdLessThan(Integer value) {
            addCriterion("cost_id <", value, "costId");
            return (Criteria) this;
        }

        public Criteria andCostIdLessThanOrEqualTo(Integer value) {
            addCriterion("cost_id <=", value, "costId");
            return (Criteria) this;
        }

        public Criteria andCostIdIn(List<Integer> values) {
            addCriterion("cost_id in", values, "costId");
            return (Criteria) this;
        }

        public Criteria andCostIdNotIn(List<Integer> values) {
            addCriterion("cost_id not in", values, "costId");
            return (Criteria) this;
        }

        public Criteria andCostIdBetween(Integer value1, Integer value2) {
            addCriterion("cost_id between", value1, value2, "costId");
            return (Criteria) this;
        }

        public Criteria andCostIdNotBetween(Integer value1, Integer value2) {
            addCriterion("cost_id not between", value1, value2, "costId");
            return (Criteria) this;
        }

        public Criteria andIsPrototypeDataFlagIsNull() {
            addCriterion("is_prototype_data_flag is null");
            return (Criteria) this;
        }

        public Criteria andIsPrototypeDataFlagIsNotNull() {
            addCriterion("is_prototype_data_flag is not null");
            return (Criteria) this;
        }

        public Criteria andIsPrototypeDataFlagEqualTo(Integer value) {
            addCriterion("is_prototype_data_flag =", value, "isPrototypeDataFlag");
            return (Criteria) this;
        }

        public Criteria andIsPrototypeDataFlagNotEqualTo(Integer value) {
            addCriterion("is_prototype_data_flag <>", value, "isPrototypeDataFlag");
            return (Criteria) this;
        }

        public Criteria andIsPrototypeDataFlagGreaterThan(Integer value) {
            addCriterion("is_prototype_data_flag >", value, "isPrototypeDataFlag");
            return (Criteria) this;
        }

        public Criteria andIsPrototypeDataFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_prototype_data_flag >=", value, "isPrototypeDataFlag");
            return (Criteria) this;
        }

        public Criteria andIsPrototypeDataFlagLessThan(Integer value) {
            addCriterion("is_prototype_data_flag <", value, "isPrototypeDataFlag");
            return (Criteria) this;
        }

        public Criteria andIsPrototypeDataFlagLessThanOrEqualTo(Integer value) {
            addCriterion("is_prototype_data_flag <=", value, "isPrototypeDataFlag");
            return (Criteria) this;
        }

        public Criteria andIsPrototypeDataFlagIn(List<Integer> values) {
            addCriterion("is_prototype_data_flag in", values, "isPrototypeDataFlag");
            return (Criteria) this;
        }

        public Criteria andIsPrototypeDataFlagNotIn(List<Integer> values) {
            addCriterion("is_prototype_data_flag not in", values, "isPrototypeDataFlag");
            return (Criteria) this;
        }

        public Criteria andIsPrototypeDataFlagBetween(Integer value1, Integer value2) {
            addCriterion("is_prototype_data_flag between", value1, value2, "isPrototypeDataFlag");
            return (Criteria) this;
        }

        public Criteria andIsPrototypeDataFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("is_prototype_data_flag not between", value1, value2, "isPrototypeDataFlag");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}